<?php

use Illuminate\Auth\UserInterface;
use Illuminate\Auth\Reminders\RemindableInterface;

class User extends Eloquent implements UserInterface, RemindableInterface {

     //protected $fillable = array('email','username','password','password_temp','code','active');
     protected $guarded = array();

	/**
	 * The database table used by the model.
	 *
	 * @var string
	 */
	protected $table = 'users';

	/**
	 * The attributes excluded from the model's JSON form.
	 *
	 * @var array
	 */
	protected $hidden = array('password');

	/**
	 * Get the unique identifier for the user.
	 *
	 * @return mixed
	 */
	public function getAuthIdentifier()
	{
		return $this->getKey();
	}

	/**
	 * Get the password for the user.
	 *
	 * @return string
	 */
	public function getAuthPassword()
	{
		return $this->password;
	}

	/**
	 * Get the e-mail address where password reminders are sent.
	 *
	 * @return string
	 */
	public function getReminderEmail()
	{
		return $this->email;
	}


   //create a relationship with use
	public function profile()
    {
        return $this->hasOne('Profile');
    }


    //get network name of current user
    public static function getNetWorkName()
    {

       $profile = User::find(Auth::user()->id)->profile;
         
        return DB::table('network')->select('name')->where('network','=',$profile->network_id)->first()->name;  
    }


     //get name of networks for populate the dropdown list 
    public static function getAllNetWorkName()
    {

      //(DB::table('network')->select('id','name')->distinct()->get());  

    	return DB::select('select distinct name ,network from network');
    }


}